www.loanperformer.com

Table of Contents (Online Help)

Import Loan Disbursements

If you've been using another financial software product, and you'd like to import loan disbursements information from that product into Loan Performer, you can do so if the product allows you to export to a spreadsheet, dBase or text file. Loan disbursements can be imported from three file formats, i.e., dBase, Microsoft Excel or Tab delimited text files. Each of these files has a standard file format on how data should be arranged.

These loan disbursements templates can be downloaded from the Loan Performer Downloads page or got from the Loan Performer working folder under the import file folder, e.g., "C:\LPF81204\External Files\Import" It will be under the file name Loan Disbursements and it looks like the one below:

• Loan Number: This has to be an existing loan number in the Loan Performer database. The loan must have been approved before the importation.
• Disbursement date: Note that this date should be on or after the loan approval date.

Importation of data from Microsoft Excel requires that either the date is entered just as a date, e.g., "02/02/2000" – which is only suitable if you have only one transaction per day – or that it is formatted as a date/time field as follows: dd/mm/yyyy:hh:mm:ss in order to allow the time differences.

• Amount disbursed: This column will have the amount that is disbursed per loan.
• Mode: Loan Performer can allow importation of three kinds of disbursement modes, i.e., 1=Cash, 2=cheque, 3=transfer from savings.
• GL. Account: General Ledger cash or bank account. This is the Loan Performer GL A/C for the account that you use for depositing your cheques or cash. You will have to fill this in, even if you have no disbursements by cheque or even if you don’t use Loan Performer for your accounting. The GL account should be an existing account.
• Recalculate due dates: This is a character field and will determine whether the repayment dates should be recalculated or changed, i.e., . No.1 = No, 2= report with difference between application and disbursement date; 3=recalculate dates; 4=recalculate due dates and due amounts.

With the importation of loan disbursements, you have to pay particular attention to the field Recalculate Due Dates. This is the field that determines whether the installment dates are reported or otherwise according to the following options (see: Disbursements).
          1. Do not report due dates.
          2. Report due dates with difference between loan application date and disbursement date.
           3. Recalculate due dates based on current disbursement date (you should always choose this option for monthly loans with interest flat rate).
         4. Recalculate due dates and due amounts (only necessary for loans on declining balance).

How to Import Loans disbursements

To import loan disbursements you go to Loans\Loan Importations\Import Loan disbursements and a screen like the one below shows up:

Files of type: Specify the import file type in the files of type: box, e.g., "Microsoft Excel File".

Import file: Specify the full path to the file that should be imported in the Import file text box, e.g., "C:\LPF81204\EXTERNAL FILES\IMP": Alternatively click on the Choose command button to select the file from a specified location.

Error File: Specify the name of the file to which errors will be written,e.g., "ImpDisb.Txt".

Import file format: This scroll window lists the various fields of the file to be imported and their properties.

Imported Files: This scroll window lists all previously imported files.

View: This button opens the selected import file and enables you to it within the corresponding application.

Click on the Import command button to import the set disbursement transactions. The following screen shows up:

Click on the Yes command button to confirm the importation. The imported file will now be displayed in the Imported Files section. See below:

Reset: When you click on this command button, the imported file log will be cleared.

Click on the Cancelbutton to exit.

Related Topics

Contact LPF live support for more information
This service requires an Internet connection.